package com.pangda.mapper;

import com.pangda.pojo.Contract;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pangda.pojo.dto.DeptDataList;
import org.apache.ibatis.annotations.Mapper;

import java.time.LocalDate;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 合同表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-06-20
 */
@Mapper
public interface ContractMapper extends BaseMapper<Contract> {

    void addContract(Contract contract);

    List<DeptDataList> selectAmountByDeptId(LocalDate beginDate, LocalDate endDate);

    List<Map<String,Object>> salesStatistics(LocalDate beginDate, LocalDate endDate);

    List<Map<String, Object>> contractStatistics(LocalDate beginDate, LocalDate endDate);

    List<Map<String, Object>> CostumerTotal(LocalDate beginDate, LocalDate endDate);
}
